UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GlNFR0HMeJcv8rQWgvTQn1vOHIonj4s02E3Pt4YYtpU='
WHERE
key_id = 'df4786180ce7c36490dee1fece5bd19dd9cf276ab6464aa98b61f3e80df4defa'
AND (
token = 'GlNFR0HMeJcv8rQWgvTQn1vOHIonj4s02E3Pt4YYtpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)