TJay Waters was captured on CCTV the day before he went missing