Police issue urgent appeal for CCTV footage