UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0yY6KKpCnfFN4ntLnWk+LocsDdex7sjOjn7DQGr/ks='
WHERE
key_id = 'cca454667c050615ed651490b78a20f3d83c448cb8f20b9efef49b898c0cd4a7'
AND (
token = 'X0yY6KKpCnfFN4ntLnWk+LocsDdex7sjOjn7DQGr/ks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)