UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Eo4E64nIH58Lm6wwv7Fjh7pyPT5FkCPgWHakAMdb6g='
WHERE
key_id = '3a9b6978134542c5cb4d5017f891a38aa003dc62499be0e8fe5434a1cff7804a'
AND (
token = '9Eo4E64nIH58Lm6wwv7Fjh7pyPT5FkCPgWHakAMdb6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)