UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7fXrnnsXgMb/bs4QupO9f/eGKzcriaSwoEtAJEcv68='
WHERE
key_id = 'c4b4c78a89cba4d6e1bfd1483d54a2e1953c42da9bee9402d87de4bc28abdad1'
AND (
token = 'q7fXrnnsXgMb/bs4QupO9f/eGKzcriaSwoEtAJEcv68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)