UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EC+p5RjZmKZAFMr6FyA/K7IYUf7eUpKhrJTG8J37hEs='
WHERE
key_id = 'a4bec7d63018476b36b7a26aef3c88056f8a10a6f75f4947dd8f6ae52031375a'
AND (
token = 'EC+p5RjZmKZAFMr6FyA/K7IYUf7eUpKhrJTG8J37hEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)