UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KQcE9cheEAOGSuZXTbZLBloSqujlZ8ho4qbLxIgGoCA='
WHERE
key_id = '6f4d451993a1f1ea4f3313576f62c2b5e440c13acec71e9027344fb84179be0e'
AND (
token = 'KQcE9cheEAOGSuZXTbZLBloSqujlZ8ho4qbLxIgGoCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)