Grundsätzlich:

update myfile
set field=newval
where field2 in (select ....)
and field3 in (select ...)
and field4 = ...