update table1
left join table2 on table1.email = table2.email
set table1.bool_col = 'true'
where table2.email is null