UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ez8awq9p50JA3VgYVcwbd5VbHA5cTfarKAKTLKYeNeU='
WHERE
key_id = 'f477f1df64463354b4e20cdfd197d88b070674be4c08381863ff6f1a3c263ba2'
AND (
token = 'Ez8awq9p50JA3VgYVcwbd5VbHA5cTfarKAKTLKYeNeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)