UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YHKfymEPPR4u9zu7CD2u81U0Dn3FgLJdMlpYgZ+Y2ZU='
WHERE
key_id = '1e9727bd1c24f170a3272fa4b31072998c44efafdbfb94c71c8f9148b84b0d22'
AND (
token = 'YHKfymEPPR4u9zu7CD2u81U0Dn3FgLJdMlpYgZ+Y2ZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)