You're welcome. To ensure you're not sending alerts twice either select and update in a transaction or use a CTE like:

  with alert as (
    select alert_id from alerts 
    where alert_sent_at is null
  )
  
  update alerts set
    alert_sent_at = now()
  from alert
  returning *