SELECT id, created_at, contact_id, status
FROM contact_status
WHERE
contact_status.id in (select max(id) as id from contact_status group by contact_id)
contact_status.status = 'authorized'
ORDER BY contact_id, created_at DESC
В случае с одной записью
SELECT id, created_at, contact_id, status
FROM contact_status
WHERE
contact_status.id in (select max(id) as id from contact_status where contact_id=121750 group by contact_id )
contact_status.status = 'authorized'
ORDER BY contact_id, created_at DESC