UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ifg7NNVeTW5tFuxrETcbYvDrCZSABeKLwItv1CvGr9w='
WHERE
key_id = '4666c07ba84f7abe9bf92c32b0951a2806b846e78b76e0766ed5293db1884fe1'
AND (
token = 'ifg7NNVeTW5tFuxrETcbYvDrCZSABeKLwItv1CvGr9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)