My my or my my my can be used for various scenarios.
If a child has done something wrong, a mother might say to her child in a scolding voice, "my my my, what have you done?"
If a girlfriend comes over for a visit wearing an attractive outfit, a boyfriend might say in a seductive voice, "my my my, don't you look hot tonight?"