Did you check their descriptions in the documentation ? There you will find all the details about the way they work.
If your case gives equivalent results with tie and MPC PIN then it’s up to you which one to use. Maybe test some other types of constraints too.