In almost all psilocybin studies, the effect is mediated by the degree to which the participant has a 'mystical-type experience.'
I don't imagine this could be experienced while unconscious, and so assuming that's correct, then it would be substantially less effective if someone was unconscious.
I would expect a small anti-depressant effect of psilocybin alone, possibly related to the serotonin 2A receptor and it's impact on well-being. But, to be very clear - the active experience of a 'mystical trip' is what causes a reduction in depression.
See:
http://journals.sagepub.com/doi/full/10.1177/026988111773127...
'Determinants of enduring effects were psilocybin-occasioned mystical-type experience'
http://journals.sagepub.com/doi/full/10.1177/026988111667551...
'The psilocybin-induced mystical experience mediated the therapeutic effect of psilocybin on anxiety and depression.'