UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8KpIQPeFEj7gwD4Gdlm+VmLdWWQg3okwiqnmBkk+AUs='
WHERE
key_id = 'ce6f9f4000568e17d967a70109c7ca461a21c58c8298f21d6d409b627189b8c6'
AND (
token = '8KpIQPeFEj7gwD4Gdlm+VmLdWWQg3okwiqnmBkk+AUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)