UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TAEs0h10/LHUlMyEXcq780iZ6SABbSsL1afOEzPbkao='
WHERE
key_id = 'b986d6544b304841df811e5f42d279c39ad3c1af9cf953d178b80ba0ac120989'
AND (
token = 'TAEs0h10/LHUlMyEXcq780iZ6SABbSsL1afOEzPbkao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)