MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t1 (id int auto_increment primary key,name varchar(4));
INSERT INTO t1(name) VALUES('foo'),('foo1'), ('foo'), ('test'), ('test'), ('test'), ('test'), ('test'), ('test'), ('test');
 CREATE TABLE t2 (id int auto_increment primary key,name varchar(4));
INSERT INTO t2(name) VALUES('bar'),('foo1'), ('bar'), ('bar'), ('bar'), ('test'), ('bar'), ('test'), ('test'), ('test');
 
Records: 10  Duplicates: 0  Warnings: 0

Records: 10  Duplicates: 0  Warnings: 0

SELECT * FROm t1;

id
name

1
foo

2
foo1

3
foo

4
test

5
test

6
test

7
test

8
test

9
test

10
test

SELECT * FROM t2;

id
name

1
bar

2
foo1

3
bar

4
bar

5
bar

6
test

7
bar

8
test

9
test

10
test

CREATE TEMPORARY table t1_temp SELECT id FROM t1 WHERE name = 'foo';

Records: 2  Duplicates: 0  Warnings: 0

update t1 
inner join t2 on t1.id=t2.id
set t1.name="foo" where t2.name="bar";

Rows matched: 5  Changed: 3  Warnings: 0

SELECT * FROM t1;

id
name

1
foo

2
foo1

3
foo

4
foo

5
foo

6
test

7
foo

8
test

9
test

10
test

select t1.id from t1 
inner join t2 on t1.id=t2.id
where t2.name="bar" AND t1.id NOT IN (SELECT id FROM t1_temp);

id

4

5

7