--- Schema
CREATE TABLE t (
       id INT8 NOT NULL DEFAULT unique_rowid(),
       instance_id INT8 NULL,
       is_active INT8 NULL,
       created_at TIMESTAMP NOT NULL,
       updated_at TIMESTAMP NOT NULL,
       CONSTRAINT "primary" PRIMARY KEY (id ASC),
       INDEX idx (instance_id ASC, is_active ASC)
);

--- Update
EXPLAIN UPDATE t SET is_active = 0, updated_at = now() WHERE (is_active = 1) AND (instance_id = 15);

            tree            |    field    |      description
----------------------------+-------------+------------------------
                            | distributed | false
                            | vectorized  | false
  count                     |             |
   └── update               |             |
        │                   | table       | t
        │                   | set         | is_active, updated_at
        │                   | strategy    | updater
        │                   | auto commit |
        └── render          |             |
             └── index-join |             |
                  │         | table       | t@primary
                  │         | key columns | id
                  └── scan  |             |
                            | table       | t@idx
                            | spans       | /15/1-/15/2