UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlmalruIq1mImKkTAH7UAVImqTN2YEV0LHS1/JTl3bs='
WHERE
key_id = '69e7699a67222bdb4ccb4a62ba3a024478316b13267c904c3b16d26914ec4c98'
AND (
token = 'ZlmalruIq1mImKkTAH7UAVImqTN2YEV0LHS1/JTl3bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)