query optimization for update nested query IN(SELECT Can we optimize this?

UPDATE TABLE_NOTE 
SET COL_NOTE_DISPLAY='BLOCK' 
WHERE COL_NOTE_BIBID = $projectID 
  AND $COL_NOTE_ID IN
      ( SELECT COL_PILENOTEREL_NOTE_ID 
        FROM TABLE_PILENOTEREL 
        WHERE $COL_PILENOTEREL_PILE_ID = $pileId
      ) ;
How about:

UPDATE 
(select * from TABLE_NOTE
where COL_NOTE_BIBID = $projectID
join TABLE_PINENOTEREL on $COL_PILENOTEREL_NOTE_ID = $COL_NOTE_ID
WHERE $COL_PILENOTEREL_PILE_ID = $pileId)
SET COL_NOTE_DISPLAY='BLOCK'