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