...
The conflict will be resolved. The OVERWRITE removes the "PRODUCT_NAME" condition from the WHERE clause and checks the target value only for existance existence of primary key columns column values (PRODUCT_ID).
The command console will no longer show the conflict and the apply process starts to apply other transactions:
...