UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fq1mtb2JEUS26OMnqONuV9kN2s3u3pP8wLRXv+7Sho0='
WHERE
key_id = 'f9180b318eae3a9c8b147d198b36ff709f5fcd29564b88afaed84b5e241aa23e'
AND (
token = 'fq1mtb2JEUS26OMnqONuV9kN2s3u3pP8wLRXv+7Sho0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)