UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RJgc7iIBl7wJQE5PV0nG7Pq8vQ6TY04SCdLPDfXF8Bw='
WHERE
key_id = 'c8827dbf750eb120cc61e84c9fbaed2f60f7d945022520bb927fd02ed498582d'
AND (
token = 'RJgc7iIBl7wJQE5PV0nG7Pq8vQ6TY04SCdLPDfXF8Bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)