This leverages the latest change in origin_visit_get and
origin_visit_status_get (paginated endpoint now) to iterate over visit and
visit status from most recent to older to try and resolve a snapshot targetting
a specific revision.
This algo got used recently in the deposit. It may serve again.
Depends on D3641
Related to D3645
Related to T645