CCTV footage shows married police officer kissed his girlfriend before shooting her