UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EYrQ9ihBb5LqpsCa0x9S7INoaINmYZ+FJI/f22obYRM='
WHERE
key_id = 'c3ebdae64396965be4899d39ec2a57ce4717ef6699aaf9aec19cc8c5e2bd35a7'
AND (
token = 'EYrQ9ihBb5LqpsCa0x9S7INoaINmYZ+FJI/f22obYRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)