MySQL update if record does not exists in other table

conditional-statements, mysql, sql

Solution

update table_to_update 
set some_column = 123
where id = 1
and id not in (select id from table_b)

Problem

I am trying to figure out if it is possible to check if a specific record exists in table B. if so, don't update table A. I have tried googling, but I only find the insert version and I'm not sure if it's even possible with an update query. Thanks in advance

Original source