UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HxKv6zjed1QDuvzJ3PL5aceqgESHIqptGj9P6g7RyZM='
WHERE
key_id = '2b0e59e5aa9a41f2b6f40cf1dcf23abf4a88e76e2d488de93e629fc33715a6ac'
AND (
token = 'HxKv6zjed1QDuvzJ3PL5aceqgESHIqptGj9P6g7RyZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)