UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aFpAzs4ZZ1IVxOu8XTHeNi7EYTZhYtOzL5VkGHRfts='
WHERE
key_id = '05c2d8f3431e89dd37f8ce55cdae682c7edb72a6b19c2ae1fd71a63bd60002f0'
AND (
token = '7aFpAzs4ZZ1IVxOu8XTHeNi7EYTZhYtOzL5VkGHRfts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)