The 43-year-old was reported missing on Sunday after he failed to return home the previous day