Claudio Pizarro made up for a penalty miss with a late winner as Champions League holders Bayern Munich beat Nantes.