UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2ZqkGPQHUqiNPC9sMt8zk8dRje0c2C/iVn5DLsTpOUk=' 
WHERE 
  key_id = 'ab160c63fdb884d170cff4891483a8ee14348123ec76fd58ed20e7582d16ca03' 
  AND (
    token = '2ZqkGPQHUqiNPC9sMt8zk8dRje0c2C/iVn5DLsTpOUk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032