UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+Y8S0hPgFHBZEiMFZ7NNCSCHcApOZX3PZKJtoykaGs='
WHERE
key_id = '9ba8150b817250ac6d95abf1c2522e93b8161da898698e17f39a7935cb6e871a'
AND (
token = '9+Y8S0hPgFHBZEiMFZ7NNCSCHcApOZX3PZKJtoykaGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)