UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QiW8Xjs7Ezc8YlMbKI4asKw74lHBmfVFjvlNuBs4Neo='
WHERE
key_id = '165e0764cbd7eace1d3c170738d4af21d21517ba8b5b3bce81e33ab813b6f084'
AND (
token = 'QiW8Xjs7Ezc8YlMbKI4asKw74lHBmfVFjvlNuBs4Neo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)