UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5d9QFCZCuyHPd3jE2oyLJbzoFo3MeG6wAbOn8NP+uC8='
WHERE
key_id = '2989b3fd731b6cd6f083d1c8f6486edc654e2111ea6e7d3067cd17725b167f7e'
AND (
token = '5d9QFCZCuyHPd3jE2oyLJbzoFo3MeG6wAbOn8NP+uC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)