Record should not be update while another program is running

select * from t for update

the for update - lock the record..until a commit or a rollback command