UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RrRL6D8nTyFNr8PveFUlcrodO+ijWbDeMv5yOfPRwjs='
WHERE
key_id = '1ab65e0e96bcdfac55b9d51af471b88d2a9fd47ee534cbb20af7440b491f824d'
AND (
token = 'RrRL6D8nTyFNr8PveFUlcrodO+ijWbDeMv5yOfPRwjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)