MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.23


CREATE TABLE t1(
        seat_id    INT,
        state      INT,
        PRIMARY KEY(seat_id)
) ENGINE=InnoDB;
INSERT INTO t1 VALUES(1,0), (2,0), (3,0), (4,0);
create temporary table t0 as SELECT * FROM t1 WHERE state = 0 LIMIT 2 LOCK IN SHARE MODE
create temporary table t2 as SELECT * FROM t1 WHERE state = 0 LIMIT 2 FOR UPDATE
Can't update table 't1' while 't2' is being created.

create temporary table t3 as SELECT * FROM t1 WHERE state = 0 LIMIT 2 FOR SHARE SKIP LOCKED
create temporary table t4 as SELECT * FROM t1 WHERE state = 0 LIMIT 2 FOR UPDATE SKIP LOCKED
Can't update table 't1' while 't4' is being created.

create table t1a like t1
insert into t1a  SELECT * FROM t1 WHERE state = 0 LIMIT 2 FOR UPDATE
create view v0 as select * from t1 FOR UPDATE
create view v1 as select * from t1 FOR UPDATE SKIP LOCKED
create view v2 as select * from t1 FOR UPDATE NOWAIT
create view v3 as select * from t1 FOR SHARE SKIP LOCKED