You can't do it in one instruction. Here's my perfered method:

if exists (select * from mytable where keyfield=keyvalue)
update ...
else
insert

-Mike