How to insert data in a certain condition column

So here I would like to insert a value 2055 in a column that parent_id conditionally called in the column which is calledsort_order the value 1 is present.
Is it possible to do this?

I read your post three or four times, but I could not understand what you are asking for. Can you explain it with some examples?

Please post some sample data and expected result