UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JAV6lx/J2bV182vUlTJLsUMKEK46NFbG76aew39P+vA='
WHERE
key_id = '504916649ab8ad1db34ae652f97daa7b97ac0a34c4390c662f1a57548e4b69d8'
AND (
token = 'JAV6lx/J2bV182vUlTJLsUMKEK46NFbG76aew39P+vA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)