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