UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9o97Ns94Tgx6VAw2NtLn+GbsTJk26mZD0j6WC4ogB0M='
WHERE
key_id = 'ef499942e42e98cf20aba4da4d2738fab1b54d1296a18bbe556a62a7ddf8d999'
AND (
token = '9o97Ns94Tgx6VAw2NtLn+GbsTJk26mZD0j6WC4ogB0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)