SQL query for FIND and REPLACE with if condition

Is it possible to make a query like that so I get the desired result in MySQL?

I want to find and replace values: under table post_meta and in post_value ".../folder/..." to "..../events/...." if parent_post = = 342. Can any one help me?