ON DUPLICATE KEY or equivalent

Have you looked into the Query Builder method replace()? (Docs here)

Or, you can include a hidden field to hold the value of the primary key field when updating a record or, for a new record the value is NULL

If ($_POST['your_key_field'] === NULL) then insert, else, update.