UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ibqes4w/EM6a31o7KTix+Y8uYTxhcVWuxsoq9Z7VM+U='
WHERE
key_id = 'd8e44d3bc687843f46dfe53815c3e78e64f887492f7a9b1d2b1b299f13739d77'
AND (
token = 'ibqes4w/EM6a31o7KTix+Y8uYTxhcVWuxsoq9Z7VM+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)