UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fNxncGimgw1jd3Qf5qPWe363debSqozgekUMkReuQmw='
WHERE
key_id = '02504b38b995605f5668384dd6c732e9d867cf3a8c6e0aa235a6e1f30cf57e14'
AND (
token = 'fNxncGimgw1jd3Qf5qPWe363debSqozgekUMkReuQmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)