UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGzTrPA1jdXgR83+lXyG+NKNWYR6i88R5K2ohsLnuCA='
WHERE
key_id = '9bc3795979e8d3689819a8c2ae41174826275af23a5cf8b7b3a4cfab0b081490'
AND (
token = 'XGzTrPA1jdXgR83+lXyG+NKNWYR6i88R5K2ohsLnuCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)