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