Problems with google sheet as sql database specificallly UPDATE

I have been using this feature for quite some time now and it perfectly worked up until now where whenever I submit an UPDATE, it just added a new row to the sheet without deleting the old row.

It seems like it is not running the code in the sheet or the trigger does not function.

Please help guys. Thank you so much.

Please provide a more detailed explanation of what you are trying to achieve,
what you have done so far, what works, what doesn’t work…

Please show your relevant blocks,
if relevant, your data or lists,
screenshots of the Designer screen or app in action,
so we can see what you are trying to do…

Right Click in Blocks Editor and select “Download Blocks as Image”
for the best image of your blocks.