Is it possible to be someone's moirail and matesprit at the same time?

Not the same person, no. You can have a moirail and a matesprite at the same time but they have to be with different people.