UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ty347yqGTqvEILcvxYZZw2WE0MtS3fOpQBU1qUq/cvU='
WHERE
key_id = 'fdc8a6e6c80006967f2a208cbef9f53dba4f326bb1064a2afb2c161c16ac0cf4'
AND (
token = 'ty347yqGTqvEILcvxYZZw2WE0MtS3fOpQBU1qUq/cvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)