Getting KEY Field From Updated Row W/ No Ident

I'm using this query to update the top 1 row:
Set rowcount 1 Update MyTable set Status = 1, sdi=999 where Status=2
set rowcount 0

The key field on the table is not an identity field.

Is there a way to get that KEY field's data (for the row that was updated)?

I tried this just to see what would happen and it returns null:
Set rowcount 1 Update MyTable set Status = 1, sdi=999 where Status=2
select @@IDENTITY
set rowcount 0

Thanks!