The challenge is deleted after an attempt, therefore you can’t find it any longer after certbot has quit.
Question: is the webroot correct? For example, if you place a test file in it, like /var/www/vhosts/mysite.com/testfile, can you access it through http://mysite.com/testfile?