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