UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BQRwKxkwJhFe8HKUFaikfTsgWmpjOfEoebKwC71n1r4='
WHERE
key_id = '814f29000e7e0232931fae5d50947e2fd2e753b1ba0e54f8576ce822bf5b98a0'
AND (
token = 'BQRwKxkwJhFe8HKUFaikfTsgWmpjOfEoebKwC71n1r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)